Deferral Use Case (Date Based Anniversary)

Date Based Products - Anniversary

Monthly Recognition

Paid In Period of Start Date — Starts at Beginning of Current Period

Invoice Amount: $120

Product Term: 6/1/2007 — 5/31/2008

Batch Period: 200706

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 6/1/2007

Deferral Start Period: 200706

Deferral End Date: 5/31/2008

Deferral End Period: 200805

Deferral Amount: $120.00

Recognition Amount: $10.00

Frequency: 1

Number of Periods: 12

Column / Period 200706 07 08 09 10 11
# Recognized 1 2 3 4 5 6
# Recognitions Left 11 10 9 8 7 6
Last $ Recognized $10.00 $10.00 $10.00 $10.00 $10.00 $10.00
Last Per Recognized 200706 200707 200708 200709 200710 200711
Next Per Recognized 200707 200708 200709 200710 200711 200712
Total Recognized $10.00 $20.00 $30.00 $40.00 $50.00 $60.00
Balance $110.00 $100.00 $90.00 $80.00 $70.00 $60.00
Close Flag 0 0 0 0 0 0

Column / Period 200712 200801 02 03 04 05
# Recognized 7 8 9 10 11 12
# Recognitions Left 5 4 3 2 1 0
Last $ Recognized $10.00 $10.00 $10.00 $10.00 $10.00 $10.00
Last Per Recognized 200712 200801 200802 200803 200804 200805
Next Per Recognized 200801 200802 200803 200804 200805 NULL
Total Recognized $70.00 $80.00 $90.00 $100.00 $110.00 $120.00
Balance $50.00 $40.00 $30.00 $20.00 $10.00 $0.00
Close Flag 0 0 0 0 0 1

Invoice Amount: $120

Product Term: 7/1/2007 — 6/30/2008

Batch Period: 200706

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 7/1/2007

Deferral Start Period: 200707

Deferral End Date: 6/30/2008

Deferral End Period: 200806

Deferral Amount: $120.00

Recognition Amount: $10.00

Frequency: 1

Number of Periods: 12

Column / Period 06 07 08 09 10 11
# Recognized 0 1 2 3 4 5
# Recognitions Left 12 11 10 9 8 7
Last $ Recognized $0.00 $10.00 $10.00 $10.00 $10.00 $10.00
Last Per Recognized NULL 200707 200708 200709 200710 200711
Next Per Recognized 200707 200708 200709 200710 200711 200712
Total Recognized $0.00 $10.00 $20.00 $30.00 $40.00 $50.00
Balance $120.00 $110.00 $100.00 $90.00 $80.00 $70.00
Close Flag 0 0 0 0 0 0

Column / Period 200712 200801 02 03 04 05 06
# Recognized 6 7 8 9 10 11 12
# Recognitions Left 6 5 4 3 2 1 0
Last $ Recognized $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00
Last Per Recognized 200712 200801 200802 200803 200804 200805 200806
Next Per Recognized 200801 200802 200803 200804 200805 200806 NULL
Total Recognized $60.00 $70.00 $80.00 $90.00 $100.00 $110.00 $120.00
Balance $60.00 $50.00 $40.00 $30.00 $20.00 $10.00 $0.00
Close Flag 0 0 0 0 0 0 1

Invoice Amount: $120

Product Term: 5/1/2007 — 4/30/2008

Batch Period: 200706

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 5/1/2007

Deferral Start Period: 200705

Deferral End Date: 4/30/2008

Deferral End Period: 200804

Deferral Amount: $120.00

Recognition Amount: $10.00

Frequency: 1

Number of Periods: 12

Column / Period 06 07 08 09 10 11
# Recognized 2 3 4 5 6 7
# Recognitions Left 10 9 8 7 6 5
Last $ Recognized $20.00 $10.00 $10.00 $10.00 $10.00 $10.00
Last Per Recognized 200706 200707 200708 200709 200710 200711
Next Per Recognized 200707 200708 200709 200710 200711 200712
Total Recognized $20.00 $30.00 $40.00 $50.00 $60.00 $70.00
Balance $100.00 $90.00 $80.00 $70.00 $60.00 $50.00
Close Flag 0 0 0 0 0 0

Column / Period 200712 200801 02 03 04
# Recognized 8 9 10 11 12
# Recognitions Left 4 3 2 1 0
Last $ Recognized $10.00 $10.00 $10.00 $10.00 $10.00
Last Per Recognized 200712 200801 200802 200803 200804
Next Per Recognized 200801 200802 200803 200804 NULL
Total Recognized $80.00 $90.00 $100.00 $110.00 $120.00
Balance $40.00 $30.00 $20.00 $10.00 $00.00
Close Flag 0 0 0 0 1

Quarterly Recognition

Invoice Amount: $120

Product Term: 6/1/2007 — 5/31/2008

Batch Period: 200706

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 6/1/2007

Deferral Start Period: 200706

Deferral End Date: 5/31/2008

Deferral End Period: 200805

Deferral Amount: $120.00

Recognition Amount: $30.00

Frequency: 3

Number of Periods: 12

Column / Period 06 07 08 09 10 11
# Recognized 0 0 3 3 3 6
# Recognitions Left 4 4 3 3 3 2
Last $ Recognized $0.00 $0.00 $30.00 $30.00 $30.00 $30.00
Last Per Recognized NULL NULL 200708 200708 200708 200711
Next Per Recognized 200708 200708 200711 200711 200711 200802
Total Recognized $0.00 $00.00 $30.00 $30.00 $30.00 $60.00
Balance $120.00 $120.00 $90.00 $90.00 $90.00 $60.00
Close Flag 0 0 0 0 0 0

Column / Period 200712 200801 02 03 04 05
# Recognized 6 6 9 9 9 12
# Recognitions Left 2 2 1 1 1 0
Last $ Recognized $30.00 $30.00 $30.00 $30.00 $30.00 $30.00
Last Per Recognized 200711 200711 200802 200802 200802 200805
Next Per Recognized 200802 200802 200805 200805 200805 NULL
Total Recognized $60.00 $60.00 $90.00 $90.00 $90.00 $120.00
Balance $60.00 $60.00 $30.00 $30.00 $30.00 $0.00
Close Flag 0 0 0 0 0 1

Invoice Amount: $120

Product Term: 7/1/2007 — 6/30/2008

Batch Period: 200706

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 7/1/2007

Deferral Start Period: 200707

Deferral End Date: 6/30/2008

Deferral End Period: 200806

Deferral Amount: $120.00

Recognition Amount: $30.00

Frequency: 3

Number of Periods: 12

Column / Period 200706 07 08 09 10 11 12
# Recognized 0 0 0 3 3 3 6
# Recognitions Left 4 4 4 3 3 3 2
Last $ Recognized $0.00 $0.00 $0.00 $30.00 $30.00 $30.00 $30.00
Last Per Recognized NULL NULL NULL 200709 200709 200709 200712
Next Per Recognized 200709 200709 200709 200712 200712 200712 200803
Total Recognized $0.00 $0.00 $0.00 $30.00 $30.00 $30.00 $60.00
Balance $120.00 $120.00 $120.00 $90.00 $90.00 $90.00 $60.00
Close Flag 0 0 0 0 0 0 0

Column / Period 200801 02 03 04 05 06
# Recognized 6 6 9 9 9 12
# Recognitions Left 2 2 1 1 1 0
Last $ Recognized $30.00 $30.00 $30.00 $30.00 $30.00 $30.00
Last Per Recognized 200712 200712 200803 200803 200803 200806
Next Per Recognized 200803 200806 200806 200806 200806 NULL
Total Recognized $60.00 $60.00 $90.00 $90.00 $90.00 $120.00
Balance $60.00 $60.00 $30.00 $30.00 $30.00 $0.00
Close Flag 0 0 0 0 0 1

Invoice Amount: $120

Product Term: 5/1/2007 — 4/30/2008

Batch Period: 200706

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 5/1/2007

Deferral Start Period: 200705

Deferral End Date: 4/30/2008

Deferral End Period: 200804

Deferral Amount: $120.00

Recognition Amount: $30.00

Frequency: 3

Number of Periods: 12

Column / Period 06 07 08 09 10 11
# Recognized 0 3 3 3 6 6
# Recognitions Left 4 3 3 3 2 2
Last $ Recognized $0.00 $30.00 $30.00 $30.00 $30.00 $30.00
Last Per Recognized NULL 200707 200707 200707 200710 200710
Next Per Recognized 200707 200710 200710 200710 200801 200801
Total Recognized $0.00 $30.00 $30.00 $30.00 $60.00 $60.00
Balance $120.00 $90.00 $90.00 $90.00 $60.00 $60.00
Close Flag 0 0 0 0 0 0

Column / Period 200712 200801 02 03 04
# Recognized 6 3 3 3 0
# Recognitions Left 2 1 1 1 0
Last $ Recognized $30.00 $30.00 $30.00 $30.00 $30.00
Last Per Recognized 200710 200801 200801 200801 200804
Next Per Recognized 200801 200804 200804 200804 NULL
Total Recognized $60.00 $90.00 $90.00 $90.00 $120.00
Balance $60.00 $30.00 $30.00 $30.00 $00.00
Close Flag 0 0 0 0 1

Semi-Annual Recognition

Invoice Amount: $120

Product Term: 6/1/2007 — 5/31/2008

Batch Period: 200706

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 6/1/2007

Deferral Start Period: 200706

Deferral End Date: 5/31/2008

Deferral End Period: 200805

Deferral Amount: $120.00

Recognition Amount: $60.00

Frequency: 6

Number of Periods: 12

Column / Period 06 07 08 09 10 11
# Recognized 0 0 0 0 0 6
# Recognitions Left 2 2 2 2 2 1
Last $ Recognized $0.00 $0.00 $0.00 $0.00 $0.00 $60.00
Last Per Recognized NULL NULL NULL NULL NULL 200711
Next Per Recognized 200711 200711 200711 200711 200711 200805
Total Recognized $0.00 $0.00 $0.00 $0.00 $0.00 $60.00
Balance $120.00 $120.00 $120.00 $120.00 $120.00 $60.00
Close Flag 0 0 0 0 0 0

Column / Period 200712 200801 02 03 04 05
# Recognized 6 6 6 6 6 12
# Recognitions Left 1 1 1 1 1 0
Last $ Recognized $60.00 $60.00 $60.00 $60.00 $60.00 $60.00
Last Per Recognized 200711 200711 200711 200711 200711 200805
Next Per Recognized 200805 200805 200805 200805 200805 NULL
Total Recognized $60.00 $60.00 $60.00 $60.00 $60.00 $120.00
Balance $60.00 $60.00 $60.00 $60.00 $60.00 $0.00
Close Flag 0 0 0 0 0 1

Invoice Amount: $120

Product Term: 7/1/2007 — 6/30/2008

Batch Period: 200706

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 7/1/2007

Deferral Start Period: 200707

Deferral End Date: 6/30/2008

Deferral End Period: 200806

Deferral Amount: $120.00

Recognition Amount: $60.00

Frequency: 6

Number of Periods: 12

Column / Period 06 07 08 09 10 11 12
# Recognized 0 0 0 0 0 0 6
# Recognitions Left 2 2 2 2 2 2 1
Last $ Recognized $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $60.00
Last Per Recognized NULL NULL NULL NULL NULL NULL 200712
Next Per Recognized 200712 200712 200712 200712 200712 200712 200806
Total Recognized $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $60.00
Balance $120.00 $120.00 $120.00 $120.00 $120.00 $120.00 $60.00
Close Flag 0 0 0 0 0 0

Column / Period 200801 02 03 04 05 06
# Recognized 6 6 6 6 6 12
# Recognitions Left 1 1 1 1 1 0
Last $ Recognized $60.00 $60.00 $60.00 $60.00 $60.00 $60.00
Last Per Recognized 200712 200712 200712 200712 200712 200806
Next Per Recognized 200806 200806 200806 200806 200806 NULL
Total Recognized $60.00 $60.00 $60.00 $60.00 $60.00 $120.00
Balance $60.00 $60.00 $60.00 $60.00 $60.00 $0.00
Close Flag 0 0 0 0 0 1

Invoice Amount: $120

Product Term: 5/1/2007 — 4/30/2008

Batch Period: 200706

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 5/1/2007

Deferral Start Period: 200705

Deferral End Date: 4/30/2008

Deferral End Period: 200804

Deferral Amount: $120.00

Recognition Amount: $60.00

Frequency: 6

Number of Periods: 12

Column / Period 06 07 08 09 10 11
# Recognized 0 0 0 0 6 6
# Recognitions Left 2 2 2 2 1 1
Last $ Recognized $0.00 $0.00 $0.00 $0.00 $60.00 $60.00
Last Per Recognized NULL NULL NULL NULL 200710 200710
Next Per Recognized 200710 200710 200710 200710 200804 200804
Total Recognized $0.00 $0.00 $0.00 $0.00 $60.00 $60.00
Balance $120.00 $120.00 $120.00 $120.00 $60.00 $60.00
Close Flag 0 0 0 0 0 0

Column / Period 200712 200801 02 03 04
# Recognized 6 6 6 6 12
# Recognitions Left 1 1 1 1 0
Last $ Recognized $60.00 $60.00 $60.00 $60.00 $60.00
Last Per Recognized 200710 200710 200710 200710 200804
Next Per Recognized 200804 200804 200804 200804 NULL
Total Recognized $60.00 $60.00 $60.00 $60.00 $120.00
Balance $60.00 $60.00 $60.00 $60.00 $00.00
Close Flag 0 0 0 0 1

Annual Recognition

Invoice Amount: $120

Product Term: 6/1/2007 — 5/31/2009

Batch Period: 200706

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 6/1/2007

Deferral Start Period: 200706

Deferral End Date: 5/31/2009

Deferral End Period: 200905

Deferral Amount: $120.00

Recognition Amount: $60.00

Frequency: 12

Number of Periods: 24

Year 1:

Column / Period 200706 07 08 09 10 11
# Recognized 0 0 0 0 0 0
# Recognitions Left 2 2 2 2 2 2
Last $ Recognized $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Last Per Recognized NULL NULL NULL NULL NULL NULL
Next Per Recognized 200805 200805 200805 200805 200805 200805
Total Recognized $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Balance $120.00 $120.00 $120.00 $120.00 $120.00 $120.00
Close Flag 0 0 0 0 0 0

Column / Period 200712 200801 02 03 04 05
# Recognized 0 0 0 0 0 12
# Recognitions Left 2 2 2 2 2 1
Last $ Recognized $0.00 $0.00 $0.00 $0.00 $0.00 $60.00
Last Per Recognized NULL NULL NULL NULL NULL 200805
Next Per Recognized 200805 200805 200805 200805 200805 200905
Total Recognized $0.00 $0.00 $0.00 $0.00 $0.00 $60.00
Balance $120.00 $120.00 $120.00 $120.00 $120.00 $60.00
Close Flag 0 0 0 0 0 0

Year 2:

Column / Period 200806 07 08 09 10 11
# Recognized 12 12 12 12 12 12
# Recognitions Left 1 1 1 1 1 1
Last $ Recognized $60.00 $60.00 $60.00 $60.00 $60.00 $60.00
Last Per Recognized 200805 200805 200805 200805 200805 200805
Next Per Recognized 200905 200905 200905 200905 200905 200905
Total Recognized $60.00 $60.00 $60.00 $60.00 $60.00 $60.00
Balance $60.00 $60.00 $60.00 $60.00 $60.00 $60.00
Close Flag 0 0 0 0 0 0

Column / Period 200812 200901 02 03 04 05
# Recognized 12 12 12 12 12 24
# Recognitions Left 1 1 1 1 1 0
Last $ Recognized $60.00 $60.00 $60.00 $60.00 $60.00 $60.00
Last Per Recognized 200805 200805 200805 200805 200805 200905
Next Per Recognized 200905 200905 200905 200905 200905 NULL
Total Recognized $60.00 $60.00 $60.00 $60.00 $60.00 $120.00
Balance $60.00 $60.00 $60.00 $60.00 $60.00 $0.00
Close Flag 0 0 0 0 0 1

Invoice Amount: $120

Product Term: 6/1/2007 — 5/31/2009

Batch Period: 200705

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 6/1/2007

Deferral Start Period: 200706

Deferral End Date: 5/31/2009

Deferral End Period: 200905

Deferral Amount: $120.00

Recognition Amount: $60.00

Frequency: 12

Number of Periods: 24

Year 1:

Column / Period 200705 06 07 08 09 10 11
# Recognized 0 0 0 0 0 0 0
# Recognitions Left 2 2 2 2 2 2 2
Last $ Recognized $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Last Per Recognized NULL NULL NULL NULL NULL NULL NULL
Next Per Recognized 200805 200805 200805 200805 200805 200805 200805
Total Recognized $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Balance $120.00 $120.00 $120.00 $120.00 $120.00 $120.00 $120.00
Close Flag 0 0 0 0 0 0 0

Column / Period 200712 200801 02 03 04 05
# Recognized 0 0 0 0 0 12
# Recognitions Left 2 2 2 2 2 1
Last $ Recognized $0.00 $0.00 $0.00 $0.00 $0.00 $60.00
Last Per Recognized NULL NULL NULL NULL NULL 200805
Next Per Recognized 200805 200805 200805 200805 200805 200905
Total Recognized $0.00 $0.00 $0.00 $0.00 $0.00 $60.00
Balance $120.00 $120.00 $120.00 $120.00 $120.00 $60.00
Close Flag 0 0 0 0 0 0

Year 2:

Column / Period 200806 07 08 09 10 11
# Recognized 12 12 12 12 12 12
# Recognitions Left 1 1 1 1 1 1
Last $ Recognized $60.00 $60.00 $60.00 $60.00 $60.00 $60.00
Last Per Recognized 200805 200805 200805 200805 200805 200805
Next Per Recognized 200905 200905 200905 200905 200905 200905
Total Recognized $60.00 $60.00 $60.00 $60.00 $60.00 $60.00
Balance $60.00 $60.00 $60.00 $60.00 $60.00 $60.00
Close Flag 0 0 0 0 0 0

Column / Period 200812 200901 02 03 04 05
# Recognized 12 12 12 12 12 24
# Recognitions Left 1 1 1 1 1 0
Last $ Recognized $60.00 $60.00 $60.00 $60.00 $60.00 $60.00
Last Per Recognized 200805 200805 200805 200805 200805 200905
Next Per Recognized 200905 200905 200905 200905 200905 NULL
Total Recognized $60.00 $60.00 $60.00 $60.00 $60.00 $120.00
Balance $60.00 $60.00 $60.00 $60.00 $60.00 $0.00
Close Flag 0 0 0 0 0 1

Invoice Amount: $120

Product Term: 6/1/2007 — 5/31/2009

Batch Period: 200707

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 6/1/2007

Deferral Start Period: 200706

Deferral End Date: 5/31/2009

Deferral End Period: 200905

Deferral Amount: $120.00

Recognition Amount: $60.00

Frequency: 12

Number of Periods: 24

Year 1:

Column / Period 200707 08 09 10 11
# Recognized 0 0 0 0 0
# Recognitions Left 2 2 2 2 2
Last $ Recognized $0.00 $0.00 $0.00 $0.00 $0.00
Last Per Recognized NULL NULL NULL NULL NULL
Next Per Recognized 200805 200805 200805 200805 200805
Total Recognized $0.00 $0.00 $0.00 $0.00 $0.00
Balance $120.00 $120.00 $120.00 $120.00 $120.00
Close Flag 0 0 0 0 0

Column / Period 12 200801 200802 03 04 05
# Recognized 0 0 0 0 0 12
# Recognitions Left 2 2 2 2 2 1
Last $ Recognized $0.00 $0.00 $0.00 $0.00 $0.00 $60.00
Last Per Recognized NULL NULL NULL NULL NULL 200805
Next Per Recognized 200805 200805 200805 200805 200805 200905
Total Recognized $0.00 $0.00 $0.00 $0.00 $0.00 $60.00
Balance $120.00 $120.00 $120.00 $120.00 $120.00 $60.00
Close Flag 0 0 0 0 0 0

Year 2:

Column / Period 200806 07 08 09 10 11
# Recognized 12 12 12 12 12 12
# Recognitions Left 1 1 1 1 1 1
Last $ Recognized $60.00 $60.00 $60.00 $60.00 $60.00 $60.00
Last Per Recognized 200805 200805 200805 200805 200805 200805
Next Per Recognized 200905 200905 200905 200905 200905 200905
Total Recognized $60.00 $60.00 $60.00 $60.00 $60.00 $60.00
Balance $60.00 $60.00 $60.00 $60.00 $60.00 $60.00
Close Flag 0 0 0 0 0 0

Column / Period 200812 200901 02 03 04 05
# Recognized 12 12 12 12 12 24
# Recognitions Left 1 1 1 1 1 0
Last $ Recognized $60.00 $60.00 $60.00 $60.00 $60.00 $60.00
Last Per Recognized 200805 200805 200805 200805 200805 200905
Next Per Recognized 200905 200905 200905 200905 200905 NULL
Total Recognized $60.00 $60.00 $60.00 $60.00 $60.00 $120.00
Balance $60.00 $60.00 $60.00 $60.00 $60.00 $0.00
Close Flag 0 0 0 0 0 1